-- Active: 1695736974675@@127.0.0.1@3306@renren_fast

/*
 Navicat Premium Data Transfer
 Source Server         : renren
 Source Server Type    : MySQL
 Source Server Version : 80100
 Source Host           : localhost:3306
 Source Schema         : test_3
 Target Server Type    : MySQL
 Target Server Version : 80100
 File Encoding         : 65001
 Date: 19/09/2023 15:18:31
 */

SET NAMES utf8mb3;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for eas_basic_clazz

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_clazz`;

CREATE TABLE
    `eas_basic_clazz` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '班级表id',
        `grade_id` bigint(0) NOT NULL COMMENT '年级id',
        `clazz_type` bigint(0) NULL DEFAULT NULL COMMENT '班级类型',
        `class_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '班级名字',
        `code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代码',
        `alias` bigint(0) NULL DEFAULT NULL COMMENT '别名',
        `gene` bigint(0) NULL DEFAULT NULL COMMENT '基因',
        `school_id` bigint(0) NOT NULL COMMENT '组织ID',
        `school_code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '组织代码',
        `type` tinyint(0) NULL DEFAULT 1 COMMENT '类型（暂不使用）1：行政；2：教学；3：重点；4：实验；5：特色。',
        `year_alias` int(0) NULL DEFAULT NULL COMMENT '学年别名',
        `section_alias` tinyint(0) NULL DEFAULT NULL COMMENT '学段别名',
        `grade_alias` smallint(0) NULL DEFAULT NULL COMMENT '年级别名',
        `number` smallint(0) NULL DEFAULT NULL COMMENT '班级编号',
        `room_id` bigint(0) NULL DEFAULT NULL COMMENT '教室编号',
        `room_code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '教室代码',
        `room_name` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '教室名称',
        `termone_total` int(0) NULL DEFAULT NULL COMMENT '上学期班级人数',
        `termtwo_total` int(0) NULL DEFAULT NULL COMMENT '下学期班级人数',
        `brief` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级简介',
        `join_year` int(0) NULL DEFAULT NULL COMMENT '入学年份',
        `status` tinyint(0) NULL DEFAULT 1 COMMENT '状态',
        `origin_id` bigint(0) NULL DEFAULT 0 COMMENT '元id(同步saas使用的元id),升班使用',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `grade_id`(`grade_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        INDEX `clazz_type`(`clazz_type`) USING BTREE,
        INDEX `organize_id`(`school_id`) USING BTREE,
        CONSTRAINT `eas_basic_clazz_ibfk_1` FOREIGN KEY (`grade_id`) REFERENCES `eas_basic_grade` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_clazz_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `eas_basic_school` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '班级表';

-- ----------------------------

-- Records of eas_basic_clazz

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_clazz`
VALUES (
        1,
        1,
        NULL,
        '高三1班',
        NULL,
        NULL,
        NULL,
        1,
        NULL,
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        1,
        0,
        '2023-08-13 02:56:12',
        -1,
        '2023-08-13 02:56:12',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_edu

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_edu`;

CREATE TABLE
    `eas_basic_edu` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '五育id',
        `education_name` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '单育名字',
        `weight` float(8, 2) NULL DEFAULT NULL COMMENT '权重',
        `illustration` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '单育说明',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '五育表';

-- ----------------------------

-- Records of eas_basic_edu

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_edu`
VALUES (
        1,
        '德育',
        NULL,
        NULL,
        '2023-08-13 03:26:39',
        -1,
        '2023-08-13 03:26:39',
        -1
    ), (
        2,
        '智育',
        NULL,
        NULL,
        '2023-08-13 03:26:53',
        -1,
        '2023-08-13 03:26:53',
        -1
    ), (
        3,
        '体育',
        NULL,
        NULL,
        '2023-08-13 03:27:06',
        -1,
        '2023-08-13 03:27:06',
        -1
    ), (
        4,
        '美育',
        NULL,
        NULL,
        '2023-08-13 03:27:19',
        -1,
        '2023-08-13 03:27:19',
        -1
    ), (
        5,
        '劳育',
        NULL,
        NULL,
        '2023-08-13 03:27:31',
        -1,
        '2023-08-13 03:27:31',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_edutheme

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_edutheme`;

CREATE TABLE
    `eas_basic_edutheme` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '五育大主题id',
        `education_id` bigint(0) NOT NULL COMMENT '单育id',
        `factor` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大主题',
        `weight` double NULL DEFAULT NULL COMMENT '权重',
        `score_collection` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分数采集方式',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `education_id`(`education_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        CONSTRAINT `eas_basic_edutheme_ibfk_1` FOREIGN KEY (`education_id`) REFERENCES `eas_basic_edu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '五育大主题表';

-- ----------------------------

-- Records of eas_basic_edutheme

-- ----------------------------

BEGIN;

INSERT INTO
    `eas_basic_edutheme`
VALUES (
        1,
        1,
        '品德评定',
        NULL,
        NULL,
        '2023-09-12 18:03:13',
        -1,
        '2023-09-12 18:03:13',
        -1
    ), (
        2,
        1,
        '奖惩记录',
        NULL,
        NULL,
        '2023-09-12 18:03:04',
        -1,
        '2023-09-12 18:03:04',
        -1
    ), (
        3,
        1,
        '德育课程',
        NULL,
        NULL,
        '2023-09-12 18:03:02',
        -1,
        '2023-09-12 18:03:02',
        -1
    ), (
        4,
        1,
        '实践活动',
        NULL,
        NULL,
        '2023-09-12 18:02:58',
        -1,
        '2023-09-12 18:02:58',
        -1
    ), (
        5,
        1,
        '网络文化',
        NULL,
        NULL,
        '2023-09-12 18:03:23',
        -1,
        '2023-09-12 18:03:23',
        -1
    ), (
        6,
        1,
        '人际关系',
        NULL,
        NULL,
        '2023-09-12 18:03:33',
        -1,
        '2023-09-12 18:03:33',
        -1
    ), (
        7,
        2,
        '课前-预习管理',
        NULL,
        NULL,
        '2023-09-12 18:04:29',
        -1,
        '2023-09-12 18:04:29',
        -1
    ), (
        8,
        2,
        '课前-学习计划管理',
        NULL,
        NULL,
        '2023-09-12 18:04:38',
        -1,
        '2023-09-12 18:04:38',
        -1
    ), (
        9,
        2,
        '课中-课堂行为数据',
        NULL,
        NULL,
        '2023-09-12 18:05:00',
        -1,
        '2023-09-12 18:05:00',
        -1
    ), (
        10,
        2,
        '课中-课堂考勤',
        NULL,
        NULL,
        '2023-09-12 18:08:37',
        -1,
        '2023-09-12 18:08:37',
        -1
    ), (
        11,
        2,
        '课后-作业管理',
        NULL,
        NULL,
        '2023-09-12 18:08:44',
        -1,
        '2023-09-12 18:08:44',
        -1
    ), (
        12,
        2,
        '课后-复习管理',
        NULL,
        NULL,
        '2023-09-12 18:09:00',
        -1,
        '2023-09-12 18:09:00',
        -1
    ), (
        13,
        2,
        '个人能力',
        NULL,
        NULL,
        '2023-09-12 18:09:07',
        -1,
        '2023-09-12 18:09:07',
        -1
    ), (
        14,
        2,
        '学业成绩',
        NULL,
        NULL,
        '2023-09-12 18:09:15',
        -1,
        '2023-09-12 18:09:15',
        -1
    ), (
        15,
        2,
        '实验与竞赛',
        NULL,
        NULL,
        '2023-09-12 18:09:22',
        -1,
        '2023-09-12 18:09:22',
        -1
    ), (
        16,
        3,
        '体检相关指标',
        NULL,
        NULL,
        '2023-09-12 18:09:45',
        -1,
        '2023-09-12 18:09:45',
        -1
    ), (
        17,
        3,
        '体能测试成绩',
        NULL,
        NULL,
        '2023-09-12 18:09:54',
        -1,
        '2023-09-12 18:09:54',
        -1
    ), (
        18,
        3,
        '体育特长',
        NULL,
        NULL,
        '2023-09-12 18:10:03',
        -1,
        '2023-09-12 18:10:03',
        -1
    ), (
        19,
        3,
        '健康生活',
        NULL,
        NULL,
        '2023-09-12 18:10:10',
        -1,
        '2023-09-12 18:10:10',
        -1
    ), (
        20,
        3,
        '心理素质',
        NULL,
        NULL,
        '2023-09-12 18:10:15',
        -1,
        '2023-09-12 18:10:15',
        -1
    ), (
        21,
        3,
        '体育课程',
        NULL,
        NULL,
        '2023-09-12 18:10:22',
        -1,
        '2023-09-12 18:10:22',
        -1
    ), (
        22,
        4,
        '美育课程',
        NULL,
        NULL,
        '2023-09-12 18:10:39',
        -1,
        '2023-09-12 18:10:39',
        -1
    ), (
        23,
        4,
        '美育成果',
        NULL,
        NULL,
        '2023-08-13 03:37:28',
        -1,
        '2023-08-13 03:37:28',
        -1
    ), (
        24,
        4,
        '美育活动',
        NULL,
        NULL,
        '2023-08-13 03:37:48',
        -1,
        '2023-08-13 03:37:48',
        -1
    ), (
        25,
        5,
        '劳动实践活动',
        NULL,
        NULL,
        '2023-09-12 18:10:51',
        -1,
        '2023-09-12 18:10:51',
        -1
    ), (
        26,
        5,
        '劳育课程',
        NULL,
        NULL,
        '2023-09-12 18:11:11',
        -1,
        '2023-09-12 18:11:11',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_grade

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_grade`;

CREATE TABLE
    `eas_basic_grade` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '年级id',
        `code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代码,',
        `alias` smallint(0) NULL DEFAULT NULL COMMENT '别名',
        `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '年级名字',
        `section_alias` tinyint(0) NULL DEFAULT NULL COMMENT '学段别名',
        `year_alias` int(0) NULL DEFAULT NULL COMMENT '学年别名,',
        `gene` bigint(0) NULL DEFAULT NULL COMMENT '基因id,',
        `number` smallint(0) NULL DEFAULT NULL COMMENT '年级人数',
        `descr` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '年级说明',
        `school_alias` bigint(0) NULL DEFAULT 0 COMMENT '校本年级别名,',
        `school_id` bigint(0) NOT NULL COMMENT '学校id',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `school_id`(`school_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        CONSTRAINT `eas_basic_grade_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `eas_basic_school` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '年级表';

-- ----------------------------

-- Records of eas_basic_grade

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_grade`
VALUES (
        1,
        '2023',
        NULL,
        '高三',
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        0,
        1,
        '2023-08-13 02:56:09',
        -1,
        '2023-08-13 02:56:09',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_school

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_school`;

CREATE TABLE
    `eas_basic_school` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '学校id',
        `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学校名字',
        `type` smallint(0) NULL DEFAULT 0 COMMENT '类型,',
        `alias` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '别名,',
        `title` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '全称,',
        `status` tinyint(0) NULL DEFAULT 0 COMMENT '状态,',
        `parameter` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL COMMENT '扩展属性,',
        `region_id1` bigint(0) NULL DEFAULT NULL COMMENT '区域ID1,',
        `region_id2` bigint(0) NULL DEFAULT NULL COMMENT '区域ID2,',
        `region_id3` bigint(0) NULL DEFAULT NULL COMMENT '区域ID3,',
        `group_id` bigint(0) NULL DEFAULT 0 COMMENT '集团编号,',
        `group_code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '集团代码,',
        `p_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '组织属性,',
        `p_dutyman` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '业务负责人,',
        `p_organize_des` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '组织简介,',
        `p_group_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '类型,',
        `p_level` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '级别,',
        `p_edu_belong` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '所属教育局,',
        `p_creator` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '创建人,',
        `p_group_belong` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '所属集团,',
        `p_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '图标,',
        `p_edb_type` bigint(0) NULL DEFAULT 0 COMMENT '教育单位类型：2省级，3市级，4区县级,',
        `p_detailed_address` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '详细地址,',
        `p_agency_contact` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '机构联系人,',
        `p_contact_tel` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '联系电话,',
        `p_service_tel` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '客服电话,',
        `p_official_website` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '机构官网,',
        `p_social_credit_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '社会信用代码,',
        `p_school_license_num` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '办学许可证号,',
        `p_legal_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '法定代表人,',
        `p_business_license` varchar(1500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '营业执照,',
        `p_running_license` varchar(1500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '办学许可证或名办非企业单位登记证,',
        `p_front_id_card` varchar(1500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '法定代表人身份证正面,',
        `p_reverse_id_card` varchar(1500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '法定代表人身份证反面,',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NOT NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE INDEX `name`(`name`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学校表';

-- ----------------------------

-- Records of eas_basic_school

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_school`
VALUES (
        1,
        '管理员',
        0,
        '',
        '',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        0,
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        0,
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '2023-08-13 02:50:59',
        -1,
        '2023-08-13 02:50:59',
        -1
    );

INSERT INTO `eas_basic_school`
VALUES (
        2,
        '示范中学',
        1,
        '',
        '',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        0,
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        0,
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        '2023-08-13 02:50:59',
        -1,
        '2023-08-13 02:50:59',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_stu

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_stu`;

CREATE TABLE
    `eas_basic_stu` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '学生id',
        `user_id` bigint(0) NOT NULL COMMENT '用户id',
        `stu_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号',
        `enrollment_year` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '入学年份',
        `class_id` bigint(0) NOT NULL COMMENT '班级id',
        `administrative_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '行政班id',
        `chinese_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '语文班级id',
        `mathe_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '数学班级id',
        `english_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '英语班级id',
        `physics_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '物理班级id',
        `chemistry_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '化学班级id',
        `biology_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '生物班级id',
        `politics_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '政治班级id',
        `history_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '历史班级id',
        `geography_clazz_id` bigint(0) NULL DEFAULT NULL COMMENT '地理班级id',
        `account_combination_id` bigint(0) NULL DEFAULT NULL COMMENT '组合id',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        `teacher_id` bigint(0) NOT NULL COMMENT '对应教师id',
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE INDEX `stu_id`(`stu_id`) USING BTREE,
        INDEX `user_id`(`user_id`) USING BTREE,
        INDEX `administrative_clazz_id`(`administrative_clazz_id`) USING BTREE,
        INDEX `chinese_clazz_id`(`chinese_clazz_id`) USING BTREE,
        INDEX `mathe_clazz_id`(`mathe_clazz_id`) USING BTREE,
        INDEX `english_clazz_id`(`english_clazz_id`) USING BTREE,
        INDEX `physics_clazz_id`(`physics_clazz_id`) USING BTREE,
        INDEX `chemistry_clazz_id`(`chemistry_clazz_id`) USING BTREE,
        INDEX `biology_clazz_id`(`biology_clazz_id`) USING BTREE,
        INDEX `politics_clazz_id`(`politics_clazz_id`) USING BTREE,
        INDEX `history_clazz_id`(`history_clazz_id`) USING BTREE,
        INDEX `geography_clazz_id`(`geography_clazz_id`) USING BTREE,
        INDEX `account_combination_id`(`account_combination_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        INDEX `grade_id`(`class_id`) USING BTREE,
        INDEX `eas_basic_stu_ibfk_13`(`teacher_id`) USING BTREE,
        CONSTRAINT `eas_basic_stu_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `eas_basic_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_10` FOREIGN KEY (`politics_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_11` FOREIGN KEY (`history_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_12` FOREIGN KEY (`geography_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_13` FOREIGN KEY (`teacher_id`) REFERENCES `eas_basic_teacher` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_14` FOREIGN KEY (`class_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_3` FOREIGN KEY (`administrative_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_4` FOREIGN KEY (`chinese_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_5` FOREIGN KEY (`mathe_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_6` FOREIGN KEY (`english_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_7` FOREIGN KEY (`physics_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_8` FOREIGN KEY (`chemistry_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_stu_ibfk_9` FOREIGN KEY (`biology_clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学生表';

-- ----------------------------

-- Records of eas_basic_stu

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_stu`
VALUES (
        1,
        3,
        '2023001',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:49',
        -1,
        '2023-09-09 16:30:49',
        -1,
        1
    ), (
        2,
        4,
        '2023002',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:50',
        -1,
        '2023-09-09 16:30:50',
        -1,
        1
    ), (
        3,
        5,
        '2023004',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:50',
        -1,
        '2023-09-09 16:30:50',
        -1,
        1
    ), (
        4,
        6,
        '2023005',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:51',
        -1,
        '2023-09-09 16:30:51',
        -1,
        1
    ), (
        5,
        7,
        '2023006',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:51',
        -1,
        '2023-09-09 16:30:51',
        -1,
        1
    ), (
        6,
        8,
        '2023007',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:52',
        -1,
        '2023-09-09 16:30:52',
        -1,
        1
    ), (
        7,
        9,
        '2023008',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:52',
        -1,
        '2023-09-09 16:30:52',
        -1,
        1
    ), (
        8,
        10,
        '2023009',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:53',
        -1,
        '2023-09-09 16:30:53',
        -1,
        1
    ), (
        9,
        11,
        '2023010',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:53',
        -1,
        '2023-09-09 16:30:53',
        -1,
        1
    ), (
        10,
        12,
        '2023011',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:54',
        -1,
        '2023-09-09 16:30:54',
        -1,
        1
    ), (
        11,
        13,
        '2023012',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:55',
        -1,
        '2023-09-09 16:30:55',
        -1,
        1
    ), (
        12,
        14,
        '2023013',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:55',
        -1,
        '2023-09-09 16:30:55',
        -1,
        1
    ), (
        13,
        15,
        '2023014',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:56',
        -1,
        '2023-09-09 16:30:56',
        -1,
        1
    ), (
        14,
        16,
        '2023015',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:56',
        -1,
        '2023-09-09 16:30:56',
        -1,
        1
    ), (
        15,
        17,
        '2023016',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:57',
        -1,
        '2023-09-09 16:30:57',
        -1,
        1
    ), (
        16,
        18,
        '2023017',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:58',
        -1,
        '2023-09-09 16:30:58',
        -1,
        1
    ), (
        17,
        19,
        '2023018',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:30:58',
        -1,
        '2023-09-09 16:30:58',
        -1,
        1
    ), (
        18,
        20,
        '2023019',
        '2023',
        1,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        NULL,
        '2023-09-09 16:31:00',
        -1,
        '2023-09-09 16:31:00',
        -1,
        1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_teacher

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_teacher`;

CREATE TABLE
    `eas_basic_teacher` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '老师id',
        `user_id` bigint(0) NOT NULL COMMENT '用户id',
        `teacher_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '老师姓名',
        `code` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代码',
        `role_alias` smallint(0) NULL DEFAULT 10 COMMENT '角色别名',
        `status` tinyint(0) NULL DEFAULT 1 COMMENT '状态, 1:正常,2:停用,3:回收站,4:删除(关闭数据),5:退休,6:离职,7:调岗,8:出国,9:身故,10:暂未在本单位任职-借出到机关,11:暂未在本单位任职-借出到事业单位,12:暂未在本单位任职-长病假13:暂未在本单位任职-进修,14:暂未在本单位任职-交流轮岗,15:暂未在本单位任职-企业实践,16:暂未在本单位任职-因公出国,17:暂未在本单位任职-离岗创业,18:暂未在本单位任职-待退休,19:暂未在本单位任职-待岗,20:暂未在本单位任职-下落不明,21:离休,22:返聘,23:暂未在本单位任职,24:其他',
        `gender` tinyint(0) NULL DEFAULT NULL COMMENT '性别：1：男性；2：女性；0：保密。',
        `avatar` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
        `parameter` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '虚拟扩展字段',
        `mobile` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '手机号码',
        `mail` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '邮箱',
        `address` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '通讯地址',
        `post` int(0) NULL DEFAULT 0 COMMENT '邮编',
        `remark` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '备注信息',
        `former_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '曾用名',
        `country` int(0) NULL DEFAULT 0 COMMENT '国籍/地区',
        `hometown` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '籍贯',
        `nation` int(0) NULL DEFAULT 0 COMMENT '民族',
        `birth_date` date NULL DEFAULT '2021-01-01' COMMENT '出生日期',
        `birth_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '出生行政地编码',
        `paperwork_type` tinyint(0) NULL DEFAULT 0 COMMENT '证件类型',
        `paperwork_sn` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '证件编号',
        `health_status` tinyint(0) NULL DEFAULT 1 COMMENT '健康状态',
        `work_year` tinyint(0) NULL DEFAULT 0 COMMENT '工龄',
        `character_type` tinyint(0) NULL DEFAULT 0 COMMENT '政治面貌',
        `part_time` datetime(0) NULL DEFAULT '2021-01-01 00:00:00' COMMENT '入党时间',
        `marital_status` tinyint(0) NULL DEFAULT 0 COMMENT '婚姻状态',
        `graduate_date` date NULL DEFAULT '2021-01-01' COMMENT '毕业时间',
        `college` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '毕业院校',
        `major` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '所学专业',
        `edu_type` tinyint(0) NULL DEFAULT 0 COMMENT '学历类型',
        `edu_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '学历名称',
        `edu_level` tinyint(0) NULL DEFAULT 0 COMMENT '学历层次',
        `level_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '学历层次名称',
        `degree_type` tinyint(0) NULL DEFAULT 0 COMMENT '学位类型',
        `degree_date` date NULL DEFAULT '2021-01-01' COMMENT '学位时间',
        `primary_clazzify` int(0) NULL DEFAULT 0 COMMENT '一级分类',
        `secondary_clazzify` int(0) NULL DEFAULT 0 COMMENT '二级分类',
        `type` tinyint(0) NULL DEFAULT 0 COMMENT '教职类别',
        `orgin` tinyint(0) NULL DEFAULT 0 COMMENT '教职来源',
        `scheme_type` int(0) NULL DEFAULT 0 COMMENT '编制类型',
        `grade` int(0) NULL DEFAULT 0 COMMENT '职称等级',
        `professional` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '职称',
        `metier` bigint(0) NULL DEFAULT 0 COMMENT '从教专业',
        `subject` bigint(0) NULL DEFAULT 0 COMMENT '从教学科',
        `staff_way` tinyint(0) NULL DEFAULT 0 COMMENT '用人形式',
        `staff_feature` tinyint(0) NULL DEFAULT 0 COMMENT '人员性质',
        `staff_kind` tinyint(0) NULL DEFAULT 0 COMMENT '人员类别',
        `staff_type` tinyint(0) NULL DEFAULT 0 COMMENT '人员类型',
        `job_kind` tinyint(0) NULL DEFAULT 0 COMMENT '岗位类别',
        `job_grade` tinyint(0) NULL DEFAULT 0 COMMENT '岗位等级',
        `work_date` date NULL DEFAULT '2021-01-01' COMMENT '参加时间',
        `office_date` date NULL DEFAULT '2021-01-01' COMMENT '获职时间',
        `join_date` date NULL DEFAULT '2021-01-01' COMMENT '进入时间',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `user_id`(`user_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        CONSTRAINT `eas_basic_teacher_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `eas_basic_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '老师表';

-- ----------------------------

-- Records of eas_basic_teacher

-- ----------------------------

BEGIN;

INSERT INTO
    `eas_basic_teacher`
VALUES (
        1,
        2,
        '张老师',
        NULL,
        10,
        1,
        NULL,
        NULL,
        NULL,
        '',
        '',
        '',
        0,
        '',
        '',
        0,
        '',
        0,
        '2021-01-01',
        '',
        0,
        '',
        1,
        0,
        0,
        '2021-01-01 00:00:00',
        0,
        '2021-01-01',
        '',
        '',
        0,
        '',
        0,
        '',
        0,
        '2021-01-01',
        0,
        0,
        0,
        0,
        0,
        0,
        '',
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        '2021-01-01',
        '2021-01-01',
        '2021-01-01',
        '2023-08-13 02:55:37',
        -1,
        '2023-08-13 02:55:37',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_teacherandclazz

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_teacherandclazz`;

CREATE TABLE
    `eas_basic_teacherandclazz` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '记录id',
        `teacher_id` bigint(0) NOT NULL COMMENT '老师id',
        `clazz_id` bigint(0) NOT NULL COMMENT '班级id',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE INDEX `teacher_id`(`teacher_id`, `clazz_id`) USING BTREE,
        INDEX `clazz_id`(`clazz_id`) USING BTREE,
        INDEX `teacher_id_2`(`teacher_id`) USING BTREE,
        CONSTRAINT `eas_basic_teacherandclazz_ibfk_2` FOREIGN KEY (`clazz_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_basic_teacherandclazz_ibfk_3` FOREIGN KEY (`teacher_id`) REFERENCES `eas_basic_teacher` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '老师_任教班级表';

-- ----------------------------

-- Records of eas_basic_teacherandclazz

-- ----------------------------

BEGIN;

INSERT INTO
    `eas_basic_teacherandclazz`
VALUES (
        1,
        1,
        1,
        '2023-08-13 02:57:36',
        -1,
        '2023-08-13 02:57:36',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_basic_user

-- ----------------------------

DROP TABLE IF EXISTS `eas_basic_user`;

CREATE TABLE
    `eas_basic_user` (
        `user_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户id',
        `school_id` bigint(0) NOT NULL COMMENT '学校id',
        `account` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '账号',
        `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
        `salt` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '加密盐，不为空',
        `status` tinyint(0) NOT NULL DEFAULT 1 COMMENT '用户状态',
        `email` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
        `mobile` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
        `parameter` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '拓展属性',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`user_id`) USING BTREE,
        UNIQUE INDEX `user_id`(`user_id`) USING BTREE,
        UNIQUE INDEX `account`(`account`) USING BTREE,
        INDEX `school_id`(`school_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        CONSTRAINT `eas_basic_user_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `eas_basic_school` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表';

-- ----------------------------

-- Records of eas_basic_user

-- ----------------------------

BEGIN;

INSERT INTO `eas_basic_user`
VALUES (
        1,
        1,
        'admin',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:51:17',
        -1,
        '2023-08-13 02:51:17',
        -1
    ), (
        2,
        2,
        'teacher123',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:51:18',
        -1,
        '2023-08-13 02:51:18',
        -1
    ), (
        3,
        2,
        'student456',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        4,
        2,
        'student4',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        5,
        2,
        'student5',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        6,
        2,
        'student6',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        7,
        2,
        'student7',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        8,
        2,
        'student8',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        9,
        2,
        'student9',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        10,
        2,
        'student10',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        11,
        2,
        'student11',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        12,
        2,
        'student12',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        13,
        2,
        'student13',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        14,
        2,
        'student14',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        15,
        2,
        'student15',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        16,
        2,
        'student16',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        17,
        2,
        'student17',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        18,
        2,
        'student18',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        19,
        2,
        'student19',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    ), (
        20,
        2,
        'student20',
        '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d',
        'YzcmCZNvbXocrsz9dm8e',
        1,
        NULL,
        NULL,
        NULL,
        '2023-08-13 02:54:11',
        -1,
        '2023-08-13 02:54:11',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_comment_keys

-- ----------------------------

DROP TABLE IF EXISTS `eas_comment_keys`;

CREATE TABLE
    `eas_comment_keys` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '关键词id',
        `education_id` bigint(0) NOT NULL COMMENT '五育id',
        `edutheme_id` bigint(0) NOT NULL COMMENT '五育大主题id',
        `eduaspect_id` bigint(0) NOT NULL COMMENT '大主题对应方面id',
        `keys` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关键词',
        `keys_level` enum('优秀', '中等', '偏差', '无') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关键词等级',
        `student_type` enum('小学', '中学', '无') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学生类型',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `education_id`(`education_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        INDEX `eas_edutheme_keys_ibfk_2`(`edutheme_id`) USING BTREE,
        INDEX `eas_edutheme_keys_ibfk_3`(`eduaspect_id`) USING BTREE,
        CONSTRAINT `eas_edutheme_keys_ibfk_1` FOREIGN KEY (`education_id`) REFERENCES `eas_basic_edu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_edutheme_keys_ibfk_2` FOREIGN KEY (`edutheme_id`) REFERENCES `eas_basic_edutheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_edutheme_keys_ibfk_3` FOREIGN KEY (`eduaspect_id`) REFERENCES `eas_edutheme_aspect` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '关键词表';

-- ----------------------------

-- Records of eas_comment_keys

-- ----------------------------

BEGIN;

COMMIT;

-- ----------------------------

-- Table structure for eas_edutheme_aspect

-- ----------------------------

DROP TABLE IF EXISTS `eas_edutheme_aspect`;

CREATE TABLE
    `eas_edutheme_aspect` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主题方面id',
        `education_id` bigint(0) NOT NULL COMMENT '单育id',
        `edutheme_id` bigint(0) NOT NULL COMMENT '五育大主题id',
        `aspect` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维度对应的方面',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `education_id`(`education_id`) USING BTREE,
        INDEX `create_by`(`create_by`) USING BTREE,
        INDEX `update_by`(`update_by`) USING BTREE,
        INDEX `eas_edutheme_aspect_ibfk_2`(`edutheme_id`) USING BTREE,
        CONSTRAINT `eas_edutheme_aspect_ibfk_1` FOREIGN KEY (`education_id`) REFERENCES `eas_basic_edu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_edutheme_aspect_ibfk_2` FOREIGN KEY (`edutheme_id`) REFERENCES `eas_basic_edutheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '五育主题对应方面表';

-- ----------------------------

-- Records of eas_edutheme_aspect

-- ----------------------------

BEGIN;

INSERT INTO
    `eas_edutheme_aspect`
VALUES (
        1,
        1,
        1,
        '理想信念',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        2,
        1,
        1,
        '行为习惯',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        3,
        1,
        1,
        '社会责任',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        4,
        1,
        2,
        '荣誉称号',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        5,
        1,
        2,
        '获奖证书',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        6,
        1,
        2,
        '惩罚记录',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        7,
        1,
        3,
        '学习成效',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        8,
        1,
        3,
        '课堂表现',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        9,
        1,
        3,
        '课外行为',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        10,
        1,
        4,
        '主题实践',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        11,
        1,
        4,
        '劳动实践',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        12,
        1,
        4,
        '研学实践',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        13,
        1,
        5,
        '网络素养',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        14,
        1,
        5,
        '网络安全',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        15,
        1,
        6,
        '待人态度',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        16,
        1,
        6,
        '待人行为',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        17,
        2,
        7,
        '预习习惯',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        18,
        2,
        7,
        '预习效果',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        19,
        2,
        8,
        '学习目标',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        20,
        2,
        8,
        '学习方法',
        '2023-08-13 04:35:30',
        -1,
        '2023-08-13 04:35:30',
        -1
    ), (
        21,
        2,
        8,
        '学习效果',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        22,
        2,
        9,
        '学习态度',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        23,
        2,
        9,
        '课堂表现',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        24,
        2,
        10,
        '请假缺勤',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        25,
        2,
        10,
        '迟到早退',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        26,
        2,
        11,
        '作业质量',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        27,
        2,
        11,
        '作业态度',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        28,
        2,
        11,
        '作业时间',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        29,
        2,
        12,
        '复习态度',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        30,
        2,
        12,
        '复习内容(科目、内容)',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        31,
        2,
        12,
        '复习效果',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        32,
        2,
        13,
        '学习能力',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        33,
        2,
        13,
        '综合能力',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        34,
        2,
        13,
        '交流能力',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        35,
        2,
        14,
        '学业分数',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        36,
        2,
        14,
        '学业水平',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        37,
        2,
        15,
        '竞赛成果(空)',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        38,
        2,
        15,
        '创新精神',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        39,
        2,
        15,
        '实验态度',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        40,
        3,
        16,
        '体检指标',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        41,
        3,
        17,
        '体能达标',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        42,
        2,
        18,
        '特长科目',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        43,
        2,
        18,
        '训练态度',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        44,
        2,
        19,
        '生活方式',
        '2023-08-13 04:46:08',
        -1,
        '2023-08-13 04:46:08',
        -1
    ), (
        45,
        3,
        19,
        '安全防护',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        46,
        3,
        20,
        '性格特点',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        47,
        3,
        20,
        '精神面貌',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        48,
        3,
        20,
        '心态特点',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        49,
        3,
        21,
        '体育活动',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        50,
        3,
        21,
        '体育课程成绩',
        '2023-08-13 04:47:32',
        -1,
        '2023-08-13 04:47:32',
        -1
    ), (
        51,
        3,
        21,
        '体育课堂表现',
        '2023-08-13 04:50:12',
        -1,
        '2023-08-13 04:50:12',
        -1
    ), (
        52,
        4,
        22,
        '课堂表现',
        '2023-08-13 04:50:13',
        -1,
        '2023-08-13 04:50:13',
        -1
    ), (
        53,
        4,
        22,
        '课程成绩',
        '2023-08-13 04:50:14',
        -1,
        '2023-08-13 04:50:14',
        -1
    ), (
        54,
        4,
        23,
        '美育成果',
        '2023-08-13 04:50:15',
        -1,
        '2023-08-13 04:50:15',
        -1
    ), (
        55,
        4,
        23,
        '成果名称',
        '2023-08-13 04:50:16',
        -1,
        '2023-08-13 04:50:16',
        -1
    ), (
        56,
        4,
        24,
        '美育实践',
        '2023-08-13 04:50:21',
        -1,
        '2023-08-13 04:50:21',
        -1
    ), (
        57,
        4,
        24,
        '活动名称',
        '2023-08-13 04:50:38',
        -1,
        '2023-08-13 04:50:38',
        -1
    ), (
        58,
        5,
        25,
        '劳动态度',
        '2023-08-13 04:49:31',
        -1,
        '2023-08-13 04:49:31',
        -1
    ), (
        59,
        5,
        25,
        '劳动感悟',
        '2023-08-13 04:49:31',
        -1,
        '2023-08-13 04:49:31',
        -1
    ), (
        60,
        5,
        26,
        '课堂表现',
        '2023-08-13 04:49:31',
        -1,
        '2023-08-13 04:49:31',
        -1
    ), (
        61,
        5,
        26,
        '课程评分',
        '2023-08-13 04:49:31',
        -1,
        '2023-08-13 04:49:31',
        -1
    );

COMMIT;

-- ----------------------------

-- Table structure for eas_stu_comments

-- ----------------------------

DROP TABLE IF EXISTS `eas_stu_comments`;

CREATE TABLE
    `eas_stu_comments` (
        `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '评语ID',
        `school_id` bigint(0) NOT NULL COMMENT '学校ID，关联eas_school表的id字段',
        `grade_id` bigint(0) NOT NULL COMMENT '年级ID，关联eas_grade表的id字段',
        `class_id` bigint(0) NOT NULL COMMENT '班级ID，关联eas_class表的id字段',
        `academic_year` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学年，例如：2023学年',
        `semester` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学期，例如：1表示第一学期，2表示第二学期',
        `comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评语内容',
        `comment_num` int(0) NOT NULL COMMENT '评语字数',
        `keywords_num` int(0) NOT NULL COMMENT '关键词个数',
        `teacher_id` bigint(0) NOT NULL COMMENT '所属老师ID，关联eas_basic_teacher表的id字段',
        `student_id` bigint(0) NOT NULL COMMENT '学生ID，关联eas_basic_student表的id字段',
        `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关键词',
        `show_stu` tinyint(0) NOT NULL COMMENT '是否展示给学生',
        `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
        `create_by` bigint(0) NULL DEFAULT -1 COMMENT '创建者',
        `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
        `update_by` bigint(0) NULL DEFAULT -1 COMMENT '更新者',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `teacher_id`(`teacher_id`) USING BTREE,
        INDEX `student_id`(`student_id`) USING BTREE,
        INDEX `eas_stu_comments_ibfk_3`(`school_id`) USING BTREE,
        INDEX `eas_stu_comments_ibfk_4`(`grade_id`) USING BTREE,
        INDEX `eas_stu_comments_ibfk_5`(`class_id`) USING BTREE,
        CONSTRAINT `eas_stu_comments_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `eas_basic_teacher` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_stu_comments_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `eas_basic_stu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
        CONSTRAINT `eas_stu_comments_ibfk_3` FOREIGN KEY (`school_id`) REFERENCES `eas_basic_school` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
        CONSTRAINT `eas_stu_comments_ibfk_4` FOREIGN KEY (`grade_id`) REFERENCES `eas_basic_grade` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
        CONSTRAINT `eas_stu_comments_ibfk_5` FOREIGN KEY (`class_id`) REFERENCES `eas_basic_clazz` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
    ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学生评语表';

-- ----------------------------

-- Records of eas_stu_comments

-- ----------------------------

BEGIN;

INSERT INTO `eas_stu_comments`
VALUES (
        1,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，但需要更加关注国家大事，注重仪表，保护个人隐私。你追求上进，从不预习，提高复习效率，学习时间零散，缺乏独立自主思考能力。你的身体协调性还可以，但体质较差，学习积极性不够。你懂得欣赏文学艺术作品，但劳动效率不高，很少参加校外劳动。希望你能够继续努力，发挥自己的优势，不断提高自己的综合素质。',
        200,
        15,
        1,
        4,
        '进步空间较大, 不太关注国家大事, 注重仪表, 不懂得保护个人隐私, 追求上进, 从不预习, 提高复习效率, 学习时间零散, 缺乏独立自主思考能力, 身体协调性还可以, 体质较差, 学习积极性不够, 艺术想象力, 懂得欣赏文学艺术作品, 劳动效率不高, 很少参加校外劳动',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        2,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位珍视国家荣誉的学生，但还需努力改进。在学习方面，你需要更加认真，不要浪费时间。同时，你也需要注重网络文化修养，不要做出与学习无关的事情。在比赛中，你需要更加积极参与，增强自律能力。在复习方面，你需要更加认真，不要浪费复习时间。学习用品准备不足，需要更加努力。身体协调性还可以，但体质较差，需要加强锻炼。作息不规律，需要更加规律。从不参加文化艺术活动，对艺术缺乏深入思考，但积极参加校内劳动，社会贡献不错。',
        200,
        15,
        1,
        3,
        '有待改进, 珍视国家荣誉, 做与学习无关的事, 不注重网络文化修养, 需要加油奋斗, 比赛参与度少, 缺乏自律, 浪费复习时间, 学习用品准备不足, 身体协调性还可以, 体质较差, 作息不规律, 从不参加文化艺术活动, 对艺术缺乏深入思考, 积极参加校内劳动, 社会贡献',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        3,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，诚实守信，要自觉遵守公共秩序，这些都是你的优点。但是，你的精神困倦，开拓能力还可以，成绩不理想，行动方案不合理，比赛行动力不足，不整理笔记，这些都是你需要改进的地方。体能基本达标，早起困难，体质较差，灵感表现力有待提高，从不参加文化艺术活动，不愿意参加劳动，劳动效率不高，这些都是你需要努力改进的地方。希望你能在未来的学习和生活中不断进步，成为更好的自己。',
        200,
        15,
        1,
        1,
        '进步空间较大, 诚实守信, 要自觉遵守公共秩序, 精神困倦, 开拓能力还可以, 成绩不理想, 行动方案不合理, 比赛行动力不足, 不整理笔记, 体能基本达标, 早起困难, 体质较差, 灵感表现力有待提高, 从不参加文化艺术活动, 不愿意参加劳动, 劳动效率不高',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        4,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中还需要改进的地方有很多，比如需要更加注重笔记的整理和复习效率的提升。同时，你也需要培养低碳环保的生活意识，减少浪费。在课堂上，你需要更加认真地听讲，避免心态易激动的情况。在学习用品准备方面，你需要更加细心，以免出现不必要的浪费。在作业方面，你需要更加重视，提高独立自主思考能力，避免盲目跟风。在体育方面，你需要加强体育锻炼，提高体质健康监测水平。在人际交往方面，你需要更加主动，积极参与集体劳动。你经常参观艺术展览，清晰明确的艺术学习目标，积极参加家务劳动',
        200,
        15,
        1,
        5,
        '有待改进, 培养低碳环保生活, 不做笔记, 心态易激动, 学习用品准备不足, 不重视作业, 缺乏独立自主思考能力, 提高复习效率, 缺课记录比较多, 需要加强体育锻炼, 不擅与人交往, 体质健康监测尚未达标, 经常参观艺术展览, 清晰明确的艺术学习目标, 积极参加家务劳动, 愿意参与集体劳动',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        5,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习上表现不错，基本执行学习计划，但还需加强实验操作能力。你的文字表达能力还可以，但表达不够清晰，需要多加练习。你有一定的观察力，但还需多参加校外劳动和社会实践。你的身体健康，但很少锻炼身体。你有时参加校外文化艺术活动，但还需提高观察能力和完成作业练习。你传承红色基因，但还需加强法律意识。希望你能够继续努力，成为更好的自己。',
        200,
        15,
        1,
        6,
        '有待改进, 法律意识欠缺, 传承红色基因, 较少参与社会公益实践, 文字表达能力还可以, 基本执行学习计划, 尚未能完成实验操作, 表达不清晰, 作业练习较少, 较好的睡眠质量, 良好的身体状态, 很少锻炼身体, 有时参加校外文化艺术活动, 一定的观察力, 积极参加校外劳动, 完成力所能及的校外劳动',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        6,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中表现出了一定的努力，但还需要加强法律意识和社会责任意识。你不懂得保护个人隐私，性格较孤僻，但较积极发言。作业不认真，提高复习效率，低到课率。学习用品准备不足，体能基本达标，体质健康监测尚未达标。你有时参加校外文化艺术活动，但艺术技巧有待加强。珍惜劳动成果，具备基本的技能水平。希望你能在未来的学习和生活中不断进步，成为更好的自己。',
        200,
        15,
        1,
        2,
        '法律意识欠缺, 社会责任意识不足, 不懂得保护个人隐私, 性格较孤僻, 较积极发言, 作业不认真, 提高复习效率, 低到课率, 学习用品准备不足, 体能基本达标, 体质健康监测尚未达标, 不良的生活习惯, 有时参加校外文化艺术活动, 艺术技巧有待加强, 珍惜劳动成果, 具备基本的技能水平',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        7,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，能够独立思考，复习不够自觉，不认真听讲，经常无故缺课。你的作息规律，良好的身体状态，有一定的挫折承受力。但是，你的阅读兴趣狭窄，开小差，需要更加努力。在艺术创新性方面，你还有提升的空间，从不参加文化艺术活动，不愿意参加劳动，劳动技能有待提高。希望你能够认真对待学习，积极参加少先队活动，不断提高自己的综合素质。',
        200,
        15,
        1,
        10,
        '进步空间较大, 积极参加少先队活动, 开小差, 阅读兴趣狭窄, 学习成绩稳定, 能够独立思考, 复习不够自觉, 不认真听讲, 经常无故缺课, 作息规律, 良好的身体状态, 有一定的挫折承受力, 艺术创新性有待提高, 从不参加文化艺术活动, 不愿意参加劳动, 劳动技能有待提高',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        8,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位积极向上的学生，善于参加集体活动，同时也不太关注社会发展新闻。你的进步空间较大，有参与社会调研，比赛认真准备，积极要求上进。虽然你的动手能力有待提高，但你已经展现出了一定的耐力和持久力。在早起方面，你有一定的困难，但经常参观艺术展览，基本的艺术欣赏能力也有所提升。你不愿意参加劳动，缺少劳动意识，希望你能在未来的学习和生活中更加努力。',
        200,
        15,
        1,
        7,
        '积极参加集体活动, 不太关注社会发展新闻, 进步空间较大, 有参与社会调研, 比赛认真准备, 积极要求上进, 动手能力有待提高, 不重视作业, 复习不够自觉, 挫折承受力欠缺, 耐力和持久力有待提高, 早起困难, 经常参观艺术展览, 基本的艺术欣赏能力, 不愿意参加劳动, 缺少劳动意识',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        9,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位学习成绩较理想的学生，但还需努力改进。你自觉遵守公共秩序，积极向先进模范人物学习，但需要注意网络文化修养。在面对挑战时，你容易气馁，需要更加坚定自己的信念。你的表现较差，需要更加努力。你不太注重笔记整理，但体质健康监测基本达标。你不规律的睡眠，耐力和持久力有待提高。你喜欢观看文艺演出，有一定的观察力，完成劳动值日工作，愿意参与集体劳动。希望你能继续努力，成为更好的自己。',
        200,
        15,
        1,
        8,
        '有待改进, 要自觉遵守公共秩序, 积极向先进模范人物学习, 不注重网络文化修养, 学习成绩较理想, 面对挑战时容易气馁, 没有提前告知缺勤原因, 表现较差, 不整理笔记, 体质健康监测基本达标, 不规律的睡眠, 耐力和持久力有待提高, 喜欢观看文艺演出, 一定的观察力, 完成劳动值日工作, 愿意参与集体劳动',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        10,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位有待改进的学生，不敢回答问题，尊重师长、同学和他人，怕困难。你的信息技术能力还可以，累积了一定的竞赛经验。你对学习目标有一定坚持，作业较为认真，但体质较差，情绪不稳定，有氧耐力有待提升。你的独特风格，积极参加校内文化艺术活动，完成力所能及的校内劳动，劳动技能好。希望你能继续努力，发挥自己的优势，改进自己的不足。',
        200,
        15,
        1,
        9,
        '有待改进, 不敢回答问题, 尊重师长、同学和他人, 怕困难, 信息技术能力还可以, 累积竞赛经验, 对学习目标有一定坚持, 作业较为认真, 再接再厉, 体质较差, 情绪不稳定, 有氧耐力有待提升, 独特风格, 积极参加校内文化艺术活动, 完成力所能及的校内劳动, 劳动技能好',
        0,
        '2023-08-14 22:53:47',
        -1,
        '2023-08-14 22:53:47',
        -1
    ), (
        11,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，但需要更加关注国家大事，注重仪表，保护个人隐私。你追求上进，从不预习，提高复习效率，学习时间零散，缺乏独立自主思考能力。你的身体协调性还可以，但体质较差，学习积极性不够。你懂得欣赏文学艺术作品，但劳动效率不高，很少参加校外劳动。希望你能够继续努力，发挥自己的优势，不断提高自己的综合素质。',
        200,
        15,
        1,
        4,
        '进步空间较大',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        12,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中表现出了一定的努力，但还需要加强法律意识和社会责任意识。你不懂得保护个人隐私，性格较孤僻，但较积极发言。作业不认真，提高复习效率，低到课率。学习用品准备不足，体能基本达标，体质健康监测尚未达标。你有时参加校外文化艺术活动，但艺术技巧有待加强。珍惜劳动成果，具备基本的技能水平。希望你能在未来的学习和生活中不断进步，成为更好的自己。',
        200,
        15,
        1,
        2,
        '法律意识欠缺',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        13,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，诚实守信，要自觉遵守公共秩序，这些都是你的优点。但是，你的精神困倦，开拓能力还可以，成绩不理想，行动方案不合理，比赛行动力不足，不整理笔记，这些都是你需要改进的地方。体能基本达标，早起困难，体质较差，灵感表现力有待提高，从不参加文化艺术活动，不愿意参加劳动，劳动效率不高，这些都是你需要努力改进的地方。希望你能在未来的学习和生活中不断进步，成为更好的自己。',
        200,
        15,
        1,
        1,
        '进步空间较大',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        14,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习上表现不错，基本执行学习计划，但还需加强实验操作能力。你的文字表达能力还可以，但表达不够清晰，需要多加练习。你有一定的观察力，但还需多参加校外劳动和社会实践。你的身体健康，但很少锻炼身体。你有时参加校外文化艺术活动，但还需提高观察能力和完成作业练习。你传承红色基因，但还需加强法律意识。希望你能够继续努力，成为更好的自己。',
        200,
        15,
        1,
        6,
        '有待改进',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        15,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中还需要改进的地方有很多，比如需要更加注重笔记的整理和复习效率的提升。同时，你也需要培养低碳环保的生活意识，减少浪费。在课堂上，你需要更加认真地听讲，避免心态易激动的情况。在学习用品准备方面，你需要更加细心，以免出现不必要的浪费。在作业方面，你需要更加重视，提高独立自主思考能力，避免盲目跟风。在体育方面，你需要加强体育锻炼，提高体质健康监测水平。在人际交往方面，你需要更加主动，积极参与集体劳动。你经常参观艺术展览，清晰明确的艺术学习目标，积极参加家务劳动',
        200,
        15,
        1,
        5,
        '有待改进',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        16,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位珍视国家荣誉的学生，但还需努力改进。在学习方面，你需要更加认真，不要浪费时间。同时，你也需要注重网络文化修养，不要做出与学习无关的事情。在比赛中，你需要更加积极参与，增强自律能力。在复习方面，你需要更加认真，不要浪费复习时间。学习用品准备不足，需要更加努力。身体协调性还可以，但体质较差，需要加强锻炼。作息不规律，需要更加规律。从不参加文化艺术活动，对艺术缺乏深入思考，但积极参加校内劳动，社会贡献不错。',
        200,
        15,
        1,
        3,
        '有待改进',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        17,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位积极向上的学生，善于参加集体活动，同时也不太关注社会发展新闻。你的进步空间较大，有参与社会调研，比赛认真准备，积极要求上进。虽然你的动手能力有待提高，但你已经展现出了一定的耐力和持久力。在早起方面，你有一定的困难，但经常参观艺术展览，基本的艺术欣赏能力也有所提升。你不愿意参加劳动，缺少劳动意识，希望你能在未来的学习和生活中更加努力。',
        200,
        15,
        1,
        7,
        '积极参加集体活动',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        18,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位有待改进的学生，不敢回答问题，尊重师长、同学和他人，怕困难。你的信息技术能力还可以，累积了一定的竞赛经验。你对学习目标有一定坚持，作业较为认真，但体质较差，情绪不稳定，有氧耐力有待提升。你的独特风格，积极参加校内文化艺术活动，完成力所能及的校内劳动，劳动技能好。希望你能继续努力，发挥自己的优势，改进自己的不足。',
        200,
        15,
        1,
        9,
        '有待改进',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        19,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你是一位学习成绩较理想的学生，但还需努力改进。你自觉遵守公共秩序，积极向先进模范人物学习，但需要注意网络文化修养。在面对挑战时，你容易气馁，需要更加坚定自己的信念。你的表现较差，需要更加努力。你不太注重笔记整理，但体质健康监测基本达标。你不规律的睡眠，耐力和持久力有待提高。你喜欢观看文艺演出，有一定的观察力，完成劳动值日工作，愿意参与集体劳动。希望你能继续努力，成为更好的自己。',
        200,
        15,
        1,
        8,
        '有待改进',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    ), (
        20,
        1,
        1,
        1,
        '2023',
        '第一学期',
        '你在学习中进步空间较大，能够独立思考，复习不够自觉，不认真听讲，经常无故缺课。你的作息规律，良好的身体状态，有一定的挫折承受力。但是，你的阅读兴趣狭窄，开小差，需要更加努力。在艺术创新性方面，你还有提升的空间，从不参加文化艺术活动，不愿意参加劳动，劳动技能有待提高。希望你能够认真对待学习，积极参加少先队活动，不断提高自己的综合素质。',
        200,
        15,
        1,
        10,
        '进步空间较大',
        1,
        '2023-08-14 22:54:07',
        -1,
        '2023-08-14 22:54:07',
        -1
    );

COMMIT;

SET FOREIGN_KEY_CHECKS = 1;